PostgreSQL products must be a version supported by the vendor.

Overview

Finding ID	Version	Rule ID	IA Controls	Severity
V-265871	CD12-00-012900	SV-265871r999519_rule		High

Description
Unsupported commercial and database systems should not be used because fixes to newly identified bugs will not be implemented by the vendor. The lack of support can result in potential vulnerabilities. Systems at unsupported servicing levels or releases will not receive security updates for new vulnerabilities, which leaves them subject to exploitation. When maintenance updates and patches are no longer available, the database software is no longer considered supported and should be upgraded or decommissioned.

Description

Unsupported commercial and database systems should not be used because fixes to newly identified bugs will not be implemented by the vendor. The lack of support can result in potential vulnerabilities. Systems at unsupported servicing levels or releases will not receive security updates for new vulnerabilities, which leaves them subject to exploitation. When maintenance updates and patches are no longer available, the database software is no longer considered supported and should be upgraded or decommissioned.

STIG	Date
Crunchy Data PostgreSQL Security Technical Implementation Guide	2024-06-12

Details

Check Text ( C-69790r999517_chk )
If new packages are available for PostgreSQL, they can be reviewed in the package manager appropriate for the server operating system: To list the version of installed PostgreSQL using psql: $ sudo su - postgres $ psql --version To list the current version of software for RPM: $ rpm -qa \| grep postgres To list the current version of software for APT: $ apt-cache policy postgres All versions of PostgreSQL will be listed here: http://www.postgresql.org/support/versioning/ All security-relevant software updates for PostgreSQL will be listed here: http://www.postgresql.org/support/security/ If PostgreSQL is not at the latest version, this is a finding.

Check Text ( C-69790r999517_chk )

If new packages are available for PostgreSQL, they can be reviewed in the package manager appropriate for the server operating system:

To list the version of installed PostgreSQL using psql:

$ sudo su - postgres
$ psql --version

To list the current version of software for RPM:

$ rpm -qa | grep postgres

To list the current version of software for APT:

$ apt-cache policy postgres

All versions of PostgreSQL will be listed here:
http://www.postgresql.org/support/versioning/

All security-relevant software updates for PostgreSQL will be listed here:
http://www.postgresql.org/support/security/

If PostgreSQL is not at the latest version, this is a finding.

Fix Text (F-69694r999518_fix)
Remove or decommission all unsupported software products. Upgrade unsupported DBMS or unsupported components to a supported version of the product.